Data access ADO.Net architecture relies on two component first is Data Provider and Second one is Data Set
DataProvider : The Data Provider is responsible for providing and maintaining the connection to the database. A DataProvider is a set of related components that work together to provide data in an efficient and performance driven manner. Basically there are four classes which are widely used by Data Provider.
Connection
Command
DataReader
DataAdapter
DataSet: The dataset is a disconnected, in-memory representation of data. It can be considered as a local copy of the relevant portions of the database. The DataSet is persisted in memory and the data in it can be manipulated and updated independent of the database.
Liked By
Write Answer
Define ADO.Net Architecture in ASP.Net?
Join MindStick Community
You have need login or register for voting of answers or question.
Anonymous User
04-Jul-2011Data access ADO.Net architecture relies on two component first is Data Provider and Second one is Data Set
DataProvider : The Data Provider is responsible for providing and maintaining the connection to the database. A DataProvider is a set of related components that work together to provide data in an efficient and performance driven manner. Basically there are four classes which are widely used by Data Provider.
DataSet: The dataset is a disconnected, in-memory representation of data. It can be considered as a local copy of the relevant portions of the database. The DataSet is persisted in memory and the data in it can be manipulated and updated independent of the database.